package learning.provider;


public class Test { 
	public static void main(String[] args) throws Exception {
//		Product p=new Product();
//		System.out.println(p.id);
//		Class.forName("org.sqlite.JDBC");
//		String url="jdbc:sqlite:/e:/databases/spmarket";
//		Connection conn=DriverManager.getConnection(url);
//		for (Product p : ProData.proList) {
//			
//			String sql="insert into product(name,price,stock) values(?,?,?)";
//			PreparedStatement ps=conn.prepareStatement(sql);
//			ps.setString(1, p.name);
//			ps.setDouble(2, p.price);
//			ps.setInt(3, p.stock);
//			if(ps.executeUpdate()>0)
//				System.out.println("add successfully");
//		}
//		conn.close();
	}

}
